create procedure [dbo].[BAEEventSetupMoveQuestionDown] @id int,
     @eventCode varchar(15) as
DECLARE @qO AS int;
     DECLARE @questionorder AS int;

    SELECT @qO = MAX(QuestionOrder) FROM EventSetupQuestion WHERE EventCode = @eventCode;

    SELECT @questionorder = QuestionOrder FROM EventSetupQuestion WHERE EventSetupQuestionID = @id;

    IF (@questionorder <@qO)
    BEGIN
        /* Move Question Up */
        UPDATE EventSetupQuestion
        SET QuestionOrder = QuestionOrder - 1
        WHERE EventCode = @eventCode AND QuestionOrder = @questionorder + 1;
    
        /* Move Question Down */
        UPDATE EventSetupQuestion
        SET QuestionOrder = QuestionOrder + 1
        WHERE EventSetupQuestionID = @id;
    END

GO